In String operator

Basic and Crystal syntax.

Usage

x in y

Tests for the presence of string x in string y.

Examples

The following examples are applicable to both Basic and Crystal syntax:

"Elm" in {customer.ADDRESS1}

TRUE, where {customer.ADDRESS1} is "1335 Elm Street".

"Elm" in {customer.ADDRESS1}

TRUE, where {customer.ADDRESS1} is "1335 Elmer Street".

"elm" in {file.MOTTO}

FALSE, where {file.MOTTO} = "Feel more energy".

(The "el" ending "feel" and the "m" beginning the word "more" are separated by a space which itself counts as an element.)

"el m" in {file.MOTTO}

TRUE, where {file.MOTTO} = "Feel more energy".

The search string "el m" this time contains the space between the l and the m, which allows for a perfect match.

Note:    The "in" operator can also be used to test for the presence of a string in a text range. For example, "V5B" in "V0A" to "V9Z".



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com